The TRANTAB procedure creates a translation table in the profile.sas7bcat catalog in your SASUSER data library. If the profile catalog cannot be opened for write access, you will receive an error similar to the following:

   ERROR: Cannot open entry xxxxx.TRANTAB for write access - catalog
          SASUSER.PROFILE is opened for read access.

When you invoke a SAS^® Enterprise Guide session, the options in the Lev1/SASApp/sasv9.cfg file are in effect for your session. One of the options in that file is RSASUSER. The RSASUSER option causes the SASUSER data library to be opened in read-only mode, so the TRANTAB table cannot be written to the profile.sas7bcat catalog.

It is not possible to create the translation table in a different directory.
To solve the problem, ask your SAS administrator or your UNIX system administrator to set the -NORSASUSER option as a restricted option for the userid that is used to create translation tables. The method for setting a restricted option is documented in Chapter 2 of the Configuration Guide for SAS^® 9.2 Foundation for UNIX^® Environments.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	Base SAS	64-bit Enabled AIX	9.1 TS1M3 SP4	9.4 TS1M0
		64-bit Enabled HP-UX	9.1 TS1M3 SP4	9.4 TS1M0
		64-bit Enabled Solaris	9.1 TS1M3 SP4	9.4 TS1M0
		HP-UX IPF	9.1 TS1M3 SP4	9.4 TS1M0
		Linux	9.1 TS1M3 SP4	9.4 TS1M0
		Linux on Itanium	9.1 TS1M3 SP4	9.4 TS1M0
		Solaris for x64	9.1 TS1M3 SP4	9.4 TS1M0

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

If you run a PROC TRANTAB step from a SAS® Enterprise Guide session, this error occurs: ERROR: Cannot open entry xxxxx.TRANTAB for write access - catalog SASUSER.PROFILE is opened for read access.

Type:	Problem Note
Priority:	medium

Date Modified:	2011-11-09 11:43:21
Date Created:	2011-11-08 13:17:26